Oracle

Samples Overview

Qarbine provides a wide variety of sample templates, and queries. Some are application oriented examples, while others are database administrator (DBA) oriented.

Below are a few of the component samples to consider. Review the Qarbine Catalog for the latest components. See the latest set of Oracle components in the folder depicted below.

  

  

A sample snapshot of components is shown below.

  

Table and View Names

This data source is at “example/Oracle/DBA/List tables and views”. It uses the “list tables” virtual query lists both the tables and views in the CO schema.

  

Columns in Prompted Table

This data source is located at “example/Oracle/DBA/Columns in @table”. It is associated with the “Oracle CO” data service. The “CO” references the Oracle sample customer orders data set. When run it presents a prompt to select a table.

  

That prompt has a formula to populate the list options which also references the “Oracle CO” data service.

After a table is selected the query is run and the results shown.

  

Indexes in Prompted Table

This data source is located at “example/Oracle/DBA/Indexes for @table”. It is associated with the “Oracle CO” data service. The “CO” references the Oracle sample customer orders data set. When run it presents a prompt to select a table.

  

That prompt has a formula to populate the list options which also references the “Oracle CO” data service.

After a table is selected the query is run and the results shown.